Release 10.1A: OpenEdge Data Management:
Database Administration

PROUTIL IDXANALYS qualifier

Displays information on index blocks.

Syntax

proutil db-name -C idxanalys

Parameters

db-name

Specifies the database to analyze.

IDXANALYS calculates the number of index blocks and the percentage of the database used by the index blocks. The _UserStatus virtual system table displays the utility’s progress. For more information, see Chapter 13, " Managing Performance."

Example

The following output is a sample display of PROUTIL IDXANALYS:

INDEX BLOCK SUMMARY FOR AREA "Order" : 11 ------------------------------------------------------- Table                  Index  Fields Levels  Blocks   Size   % Util Factor PUB.BillTo   custnumbillto          46       2      1       1     27B     2.7     1.0 PUB.Order   CustOrder              48       2      2      44   39.1K    91.4     1.5   OrderDate              49       1      2      33   18.5K    57.7     2.1   OrderNum               47       1      2      38   35.3K    95.5     1.5   OrderStatus            50       1      2       7   3808B    54.6     2.1   SalesRep               51       1      2       9   6226B    69.5     1.9 PUB.OrderLine   itemnum                23       1      2      56   36.6K    67.2     1.9   orderline              22       2      3     139  132.7K    98.2     1.0   OrderLineStatus        24       1      2      10   7354B    73.8     1.8 PUB.ShipTo   custnumshipto          45       2      1       1     36B     3.6     1.0